SELECT qrySalesVsForecast.TM_Number, qrySalesVsForecast.[TM NAME], qrySalesVsForecast.Period, qrySalesVsForecast.Quarter, qrySalesVsForecast.Month, qrySalesVsForecast.[Brady Actual], qrySalesVsForecast.[Brady Forecast], qryPriorYearSales_Crosstab.Brady AS [Brady Prior Year], IIf([Brady Actual<>0],([Brady Actual]/[Brady Forecast]*100),0) AS [Brady % to Plan], IIf([Brady Prior Year]<>0,([Brady Actual]/[Brady Prior Year]*100),0) AS [Brady % to Prior Year], qrySalesVsForecast.[Tachy Act], qrySalesVsForecast.[Tachy Forecast], qryPriorYearSales_Crosstab.Tachy AS [Tachy Prior Year], IIf([Tachy Forecast]<>0,([Tachy Actual]/[Tachy Forecast]*100),0) AS [Tachy % to Plan], IIf([Tachy Prior Year]<>0,([Tachy Actual]/[Tachy Prior Year]*100),0) AS [Tachy % to Prior Year], qrySalesVsForecast.[EP Act], qrySalesVsForecast.[EP Forecast], qryPriorYearSales_Crosstab.EP AS [EP Prior Year], IIf([EP Forecast]<>0,([EP Actual]/[EP Forecast]*100),0) AS [EP % to Plan], IIf([EP Prior Year]<>0,([EP Actual]/[EP Prior Year]*100),0) AS [EP % to Prior Year], qrySalesVsForecast.[ESI Act], qrySalesVsForecast.[ESI Forecast], qryPriorYearSales_Crosstab.ESI AS [ESI Prior Year], IIf([ESI Forecast]<>0,([ESI Actual]/[ESI Forecast]*100),0) AS [ESI % to Plan], IIf([ESI Prior Year]<>0,([ESI Actual]/[ESI Prior Year]*100),0) AS [ESI % to Prior Year], qrySalesVsForecast.[Angio-Seal Act], qrySalesVsForecast.[Angio-Seal Forecast], qryPriorYearSales_Crosstab.[Angio-Seal] AS [Angio-Seal Prior Year], IIf([Angio-Seal Forecast]<>0,([Angio-Seal Actual]/[Angio-Seal Forecast]*100),0) AS [Angio-Seal % to Plan], IIf([Angio-Seal Prior Year]<>0,([Angio-Seal Actual]/[Angio-Seal Prior Year]*100),0) AS [Angio-Seal % to Prior Year], qrySalesVsForecast.[CVA Act], qrySalesVsForecast.[CVA Forecast], qryPriorYearSales_Crosstab.CVA AS [CVA Prior Year], IIf([CVA Forecast]<>0,([CVA Actual]/[CVA Forecast]*100),0) AS [CVA % to Plan], IIf([CVA Prior Year]<>0,([CVA Actual]/[CVA Prior Year]*100),0) AS [CVA % to Prior Year], qrySalesVsForecast.[Mech Valves Act], qrySalesVsForecast.[Mech Valves Forecast], qryPriorYearSales_Crosstab.[Mech Valves] AS [Mech Valves Prior Year], IIf([Mech Valves Forecast]<>0,([Mech Valves Actual]/[Mech Valves Forecast]*100),0) AS [Mech Valves% to Plan], IIf([Mech Valves Prior Year]<>0,([Mech Valves Actual]/[Mech Valves Prior Year]*100),0) AS [Mech Valves % to Prior Year], qrySalesVsForecast.[Tissue Valves Act], qrySalesVsForecast.[Tissue Valves Forecast], qryPriorYearSales_Crosstab.[Tissue Valves] AS [Tissue Valves Prior Year], IIf([Tissue Valves Forecast]<>0,([Tissue Valves Actual]/[Tissue Valves Forecast]*100),0) AS [Tissue Valves % to Plan], IIf([Tissue Valves Prior Year]<>0,([Tissue Valves Actual]/[Tissue Valves Prior Year]*100),0) AS [Tissue Valves % to Prior Year], qrySalesVsForecast.[Repair Act], qrySalesVsForecast.[Repair Forecast], qryPriorYearSales_Crosstab.Repair AS [Repair Prior Year], IIf([Repair Forecast]<>0,([Repair Actual]/[Repair Forecast]*100),0) AS [Repair % to Plan], IIf([Repair Prior Year]<>0,([Repair Actual]/[Repair Prior Year]*100),0) AS [Repair % to Prior Year], qrySalesVsForecast.[Total Sales], qrySalesVsForecast.[Forecasted Sales], qryPriorYearSales_Crosstab.[Total Sales] AS [Total Sales Prior Year], IIf([Forecasted Sales]<>0,([Total Sales]/[Forecasted Sales]*100),0) AS [Total % to Plan], IIf([Total Sales Prior Year]<>0,([Total Salesl]/[Total Sales Prior Year]*100),0) AS [Total % to Prior Year]
FROM qrySalesVsForecast INNER JOIN qryPriorYearSales_Crosstab ON (qrySalesVsForecast.Period = qryPriorYearSales_Crosstab.period) AND (qrySalesVsForecast.TM_Number = qryPriorYearSales_Crosstab.[SALES PERSON]);

This shit is bananas...BA-NA-NA-S.